mysqldump 常用选项

导出脚本.

mysqldump   -h 10.253.129.177 -u archery -pf0cP*6cdrdYJ  --no-create-info --skip-create-options --skip-add-drop-table --skip-column-statistics --set-gtid-purged=OFF --single-transaction rule_engine   strategy_node_item_execution_record |gzip >strategy_node_item_execution_record.gz
#mysqldump   -h 10.253.129.177 -u archery -pf0cP*6cdrdYJ  -d --no-create-info --skip-create-options --skip-add-drop-table --skip-column-statistics --set-gtid-purged=OFF --single-transaction rule_engine   strategy_node_item_execution_record  >  strategy_node_item_execution_record.sql

导入脚本

nohup gunzip <  strategy_node_item_execution_record.gz  |  mysql -h 10.253.129.177 -u archery -pf0cP*6cdrdYJ test > strategy_node_item_execution_record.log 2>&1 &